{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生完成统计</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生姓名</td>\n",
       "      <td>学号/工号</td>\n",
       "      <td>院系</td>\n",
       "      <td>专业</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>林福滨</td>\n",
       "      <td>20231310154</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>周昊</td>\n",
       "      <td>20231310153</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>曹梓扬</td>\n",
       "      <td>20231310152</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>伍际硕</td>\n",
       "      <td>20231310151</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>文涛</td>\n",
       "      <td>20231310150</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>胡星婷</td>\n",
       "      <td>20231310149</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>向志诚</td>\n",
       "      <td>20231310148</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>翁赵熠</td>\n",
       "      <td>20231310147</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>林楠</td>\n",
       "      <td>20231310146</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朱德伟</td>\n",
       "      <td>20231310145</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>唐塬智</td>\n",
       "      <td>20231310144</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>陈治燃</td>\n",
       "      <td>20231310143</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11/11</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>刘硕</td>\n",
       "      <td>20231310142</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>4/11</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>马均宇</td>\n",
       "      <td>20231310141</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>吴岩</td>\n",
       "      <td>20231310140</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>马海悦</td>\n",
       "      <td>20231310138</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>陈烨坤</td>\n",
       "      <td>20231310137</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>赵静怡</td>\n",
       "      <td>20231310136</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>余姗珊</td>\n",
       "      <td>20231310135</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>侯绍平</td>\n",
       "      <td>20231310134</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>罗瀛</td>\n",
       "      <td>20231310133</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>陈皓晗</td>\n",
       "      <td>20231310132</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>朱淇蔓</td>\n",
       "      <td>20231310131</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>吴俊鎔</td>\n",
       "      <td>20231310130</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>王庆南</td>\n",
       "      <td>20231310129</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>傅英姿</td>\n",
       "      <td>20231310128</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>林坤宇</td>\n",
       "      <td>20231310127</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>林凯怡</td>\n",
       "      <td>20231310125</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>陈梦雪</td>\n",
       "      <td>20231310124</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>张润泽</td>\n",
       "      <td>20231310123</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>李凌翔</td>\n",
       "      <td>20231310122</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>庄杰雄</td>\n",
       "      <td>20231310121</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>林欣</td>\n",
       "      <td>20231310120</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>倪旭昶</td>\n",
       "      <td>20231310119</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>林琦凤</td>\n",
       "      <td>20231310118</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>陈佳伟</td>\n",
       "      <td>20231310117</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>陈龙</td>\n",
       "      <td>20231310116</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>李冬怡</td>\n",
       "      <td>20231310115</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>林佳怡</td>\n",
       "      <td>20231310114</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>姚鸿斌</td>\n",
       "      <td>20231310113</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>徐伟涛</td>\n",
       "      <td>20231310112</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>林志杰</td>\n",
       "      <td>20231310111</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>葛榛</td>\n",
       "      <td>20231310110</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>施广旭</td>\n",
       "      <td>20231310109</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>陆湘雄</td>\n",
       "      <td>20231310108</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>卢述桔</td>\n",
       "      <td>20231310107</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>张鹏泉</td>\n",
       "      <td>20231310106</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈嘉诚</td>\n",
       "      <td>20231310105</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>金婉欣</td>\n",
       "      <td>20231310104</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>叶亦坤</td>\n",
       "      <td>20231310103</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              学生完成统计   Unnamed: 1 Unnamed: 2  \\\n",
       "0   课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31          NaN        NaN   \n",
       "1                                               学生姓名        学号/工号         院系   \n",
       "2                                                林福滨  20231310154        工学院   \n",
       "3                                                 周昊  20231310153        工学院   \n",
       "4                                                曹梓扬  20231310152        工学院   \n",
       "5                                                伍际硕  20231310151        工学院   \n",
       "6                                                 文涛  20231310150        工学院   \n",
       "7                                                胡星婷  20231310149        工学院   \n",
       "8                                                向志诚  20231310148        工学院   \n",
       "9                                                翁赵熠  20231310147        工学院   \n",
       "10                                                林楠  20231310146        工学院   \n",
       "11                                               朱德伟  20231310145        工学院   \n",
       "12                                               唐塬智  20231310144        工学院   \n",
       "13                                               陈治燃  20231310143        工学院   \n",
       "14                                                刘硕  20231310142        工学院   \n",
       "15                                               马均宇  20231310141        工学院   \n",
       "16                                                吴岩  20231310140        工学院   \n",
       "17                                               马海悦  20231310138        工学院   \n",
       "18                                               陈烨坤  20231310137        工学院   \n",
       "19                                               赵静怡  20231310136        工学院   \n",
       "20                                               余姗珊  20231310135        工学院   \n",
       "21                                               侯绍平  20231310134        工学院   \n",
       "22                                                罗瀛  20231310133        工学院   \n",
       "23                                               陈皓晗  20231310132        工学院   \n",
       "24                                               朱淇蔓  20231310131        工学院   \n",
       "25                                               吴俊鎔  20231310130        工学院   \n",
       "26                                               王庆南  20231310129        工学院   \n",
       "27                                               傅英姿  20231310128        工学院   \n",
       "28                                               林坤宇  20231310127        工学院   \n",
       "29                                               林凯怡  20231310125        工学院   \n",
       "30                                               陈梦雪  20231310124        工学院   \n",
       "31                                               张润泽  20231310123        工学院   \n",
       "32                                               李凌翔  20231310122        工学院   \n",
       "33                                               庄杰雄  20231310121        工学院   \n",
       "34                                                林欣  20231310120        工学院   \n",
       "35                                               倪旭昶  20231310119        工学院   \n",
       "36                                               林琦凤  20231310118        工学院   \n",
       "37                                               陈佳伟  20231310117        工学院   \n",
       "38                                                陈龙  20231310116        工学院   \n",
       "39                                               李冬怡  20231310115        工学院   \n",
       "40                                               林佳怡  20231310114        工学院   \n",
       "41                                               姚鸿斌  20231310113        工学院   \n",
       "42                                               徐伟涛  20231310112        工学院   \n",
       "43                                               林志杰  20231310111        工学院   \n",
       "44                                                葛榛  20231310110        工学院   \n",
       "45                                               施广旭  20231310109        工学院   \n",
       "46                                               陆湘雄  20231310108        工学院   \n",
       "47                                               卢述桔  20231310107        工学院   \n",
       "48                                               张鹏泉  20231310106        工学院   \n",
       "49                                               陈嘉诚  20231310105        工学院   \n",
       "50                                               金婉欣  20231310104        工学院   \n",
       "51                                               叶亦坤  20231310103        工学院   \n",
       "52                                               郑佳荣  20231310102        工学院   \n",
       "53                                                陈昊  20231310101        工学院   \n",
       "54                                               苏梓珊  20221310220        工学院   \n",
       "55                                               刘宸言  20221310205        工学院   \n",
       "56                                               朱文清   2018126105        工学院   \n",
       "\n",
       "   Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8  \\\n",
       "0         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "1          专业         班级        提交数        被批阅        最高分        最低分   \n",
       "2       大数据技术     数据2311       7/11        0/7          0          0   \n",
       "3       大数据技术     数据2311       6/11        0/6          0          0   \n",
       "4       大数据技术     数据2311       5/11        0/5          0          0   \n",
       "5       大数据技术     数据2311       7/11        0/7          0          0   \n",
       "6       大数据技术     数据2311       5/11        0/5          0          0   \n",
       "7       大数据技术     数据2311      10/11       0/10          0          0   \n",
       "8       大数据技术     数据2311       7/11        0/7          0          0   \n",
       "9       大数据技术     数据2311      10/11       0/10          0          0   \n",
       "10      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "11      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "12      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "13      大数据技术     数据2311      11/11       0/11          0          0   \n",
       "14      大数据技术     数据2311       4/11        0/4          0          0   \n",
       "15      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "16      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "17      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "18      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "19      大数据技术     数据2311       7/11        0/7          0          0   \n",
       "20      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "21      大数据技术     数据2311       6/11        0/6          0          0   \n",
       "22      大数据技术     数据2311       8/11        0/8          0          0   \n",
       "23      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "24      大数据技术     数据2311       0/11        0/0          0          0   \n",
       "25      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "26      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "27      大数据技术     数据2311       7/11        0/7          0          0   \n",
       "28      大数据技术     数据2311       8/11        0/8          0          0   \n",
       "29      大数据技术     数据2311       7/11        0/7          0          0   \n",
       "30      大数据技术     数据2311       5/11        0/5          0          0   \n",
       "31      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "32      大数据技术     数据2311       6/11        0/6          0          0   \n",
       "33      大数据技术     数据2311       8/11        0/8          0          0   \n",
       "34      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "35      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "36      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "37      大数据技术     数据2311       6/11        0/6          0          0   \n",
       "38      大数据技术     数据2311       7/11        0/7          0          0   \n",
       "39      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "40      大数据技术     数据2311       8/11        0/8          0          0   \n",
       "41      大数据技术     数据2311       6/11        0/6          0          0   \n",
       "42      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "43      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "44      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "45      大数据技术     数据2311       9/11        0/9          0          0   \n",
       "46      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "47      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "48      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "49      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "50      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "51      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "52      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "53      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "54      大数据技术     数据2311       8/11        0/8          0          0   \n",
       "55      大数据技术     数据2311      10/11       0/10          0          0   \n",
       "56      大数据技术     数据2311       5/11        0/5          0          0   \n",
       "\n",
       "    Unnamed: 9  \n",
       "0          NaN  \n",
       "1   平均分(计算已批阅)  \n",
       "2            0  \n",
       "3            0  \n",
       "4            0  \n",
       "5            0  \n",
       "6            0  \n",
       "7            0  \n",
       "8            0  \n",
       "9            0  \n",
       "10           0  \n",
       "11           0  \n",
       "12           0  \n",
       "13           0  \n",
       "14           0  \n",
       "15           0  \n",
       "16           0  \n",
       "17           0  \n",
       "18           0  \n",
       "19           0  \n",
       "20           0  \n",
       "21           0  \n",
       "22           0  \n",
       "23           0  \n",
       "24           0  \n",
       "25           0  \n",
       "26           0  \n",
       "27           0  \n",
       "28           0  \n",
       "29           0  \n",
       "30           0  \n",
       "31           0  \n",
       "32           0  \n",
       "33           0  \n",
       "34           0  \n",
       "35           0  \n",
       "36           0  \n",
       "37           0  \n",
       "38           0  \n",
       "39           0  \n",
       "40           0  \n",
       "41           0  \n",
       "42           0  \n",
       "43           0  \n",
       "44           0  \n",
       "45           0  \n",
       "46           0  \n",
       "47           0  \n",
       "48           0  \n",
       "49           0  \n",
       "50           0  \n",
       "51           0  \n",
       "52           0  \n",
       "53           0  \n",
       "54           0  \n",
       "55           0  \n",
       "56           0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy2311 = pd.read_excel('数据2311学生完成统计.xlsx' )\n",
    "zy2311"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生完成统计</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生姓名</td>\n",
       "      <td>学号/工号</td>\n",
       "      <td>院系</td>\n",
       "      <td>专业</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>林敬耀</td>\n",
       "      <td>20231310249</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>钟雨渲</td>\n",
       "      <td>20231310248</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>饶煌彪</td>\n",
       "      <td>20231310247</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>黄朱晴</td>\n",
       "      <td>20231310246</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>郭佳琪</td>\n",
       "      <td>20231310245</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11/14</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>肖艳妮</td>\n",
       "      <td>20231310244</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>14/14</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>陈国洪</td>\n",
       "      <td>20231310243</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>陈渝儿</td>\n",
       "      <td>20231310242</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>王伟凡</td>\n",
       "      <td>20231310241</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>陈慧真</td>\n",
       "      <td>20231310240</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>曹俊豪</td>\n",
       "      <td>20231310239</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>陈灿贤</td>\n",
       "      <td>20231310237</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>陈隆嘉</td>\n",
       "      <td>20231310236</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>颜悦婷</td>\n",
       "      <td>20231310235</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>鲁家灿</td>\n",
       "      <td>20231310234</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>钱孟杰</td>\n",
       "      <td>20231310233</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>郭可怡</td>\n",
       "      <td>20231310232</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>车炯</td>\n",
       "      <td>20231310231</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>林元曦</td>\n",
       "      <td>20231310230</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>王炉垚</td>\n",
       "      <td>20231310229</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>张斌彬</td>\n",
       "      <td>20231310227</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>陈瑞枫</td>\n",
       "      <td>20231310226</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>王标凌</td>\n",
       "      <td>20231310225</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11/14</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>任志洋</td>\n",
       "      <td>20231310224</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>张志鹏</td>\n",
       "      <td>20231310223</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>林传江</td>\n",
       "      <td>20231310222</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>2/14</td>\n",
       "      <td>0/2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>詹方煜</td>\n",
       "      <td>20231310221</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>翁诚峰</td>\n",
       "      <td>20231310220</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>吴思钰</td>\n",
       "      <td>20231310219</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>李家烨</td>\n",
       "      <td>20231310218</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>林涛</td>\n",
       "      <td>20231310217</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>苏源城</td>\n",
       "      <td>20231310216</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>陈佳阳</td>\n",
       "      <td>20231310215</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>王正元</td>\n",
       "      <td>20231310214</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>吴丽媛</td>\n",
       "      <td>20231310213</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>林金</td>\n",
       "      <td>20231310212</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>钟淑川</td>\n",
       "      <td>20231310211</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>黄锦弘</td>\n",
       "      <td>20231310210</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>苏增宏</td>\n",
       "      <td>20231310209</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>叶有鑫</td>\n",
       "      <td>20231310208</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>叶育贤</td>\n",
       "      <td>20231310207</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>陈双俊</td>\n",
       "      <td>20231310206</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>吴泰成</td>\n",
       "      <td>20231310205</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>卢作培</td>\n",
       "      <td>20231310204</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1/14</td>\n",
       "      <td>0/1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>傅景华</td>\n",
       "      <td>20231310201</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              学生完成统计   Unnamed: 1 Unnamed: 2  \\\n",
       "0   课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31          NaN        NaN   \n",
       "1                                               学生姓名        学号/工号         院系   \n",
       "2                                                陈欣蕾  20231790208        工学院   \n",
       "3                                                 陈昊  20231310251        工学院   \n",
       "4                                                 贾兆  20231310250        工学院   \n",
       "5                                                林敬耀  20231310249        工学院   \n",
       "6                                                钟雨渲  20231310248        工学院   \n",
       "7                                                饶煌彪  20231310247        工学院   \n",
       "8                                                黄朱晴  20231310246        工学院   \n",
       "9                                                郭佳琪  20231310245        工学院   \n",
       "10                                               肖艳妮  20231310244        工学院   \n",
       "11                                               陈国洪  20231310243        工学院   \n",
       "12                                               陈渝儿  20231310242        工学院   \n",
       "13                                               王伟凡  20231310241        工学院   \n",
       "14                                               陈慧真  20231310240        工学院   \n",
       "15                                               曹俊豪  20231310239        工学院   \n",
       "16                                               陈灿贤  20231310237        工学院   \n",
       "17                                               陈隆嘉  20231310236        工学院   \n",
       "18                                               颜悦婷  20231310235        工学院   \n",
       "19                                               鲁家灿  20231310234        工学院   \n",
       "20                                               钱孟杰  20231310233        工学院   \n",
       "21                                               郭可怡  20231310232        工学院   \n",
       "22                                                车炯  20231310231        工学院   \n",
       "23                                               林元曦  20231310230        工学院   \n",
       "24                                               王炉垚  20231310229        工学院   \n",
       "25                                               张斌彬  20231310227        工学院   \n",
       "26                                               陈瑞枫  20231310226        工学院   \n",
       "27                                               王标凌  20231310225        工学院   \n",
       "28                                               任志洋  20231310224        工学院   \n",
       "29                                               张志鹏  20231310223        工学院   \n",
       "30                                               林传江  20231310222        工学院   \n",
       "31                                               詹方煜  20231310221        工学院   \n",
       "32                                               翁诚峰  20231310220        工学院   \n",
       "33                                               吴思钰  20231310219        工学院   \n",
       "34                                               李家烨  20231310218        工学院   \n",
       "35                                                林涛  20231310217        工学院   \n",
       "36                                               苏源城  20231310216        工学院   \n",
       "37                                               陈佳阳  20231310215        工学院   \n",
       "38                                               王正元  20231310214        工学院   \n",
       "39                                               吴丽媛  20231310213        工学院   \n",
       "40                                                林金  20231310212        工学院   \n",
       "41                                               钟淑川  20231310211        工学院   \n",
       "42                                               黄锦弘  20231310210        工学院   \n",
       "43                                               苏增宏  20231310209        工学院   \n",
       "44                                               叶有鑫  20231310208        工学院   \n",
       "45                                               叶育贤  20231310207        工学院   \n",
       "46                                               陈双俊  20231310206        工学院   \n",
       "47                                               吴泰成  20231310205        工学院   \n",
       "48                                               卢作培  20231310204        工学院   \n",
       "49                                               邱粤汉  20231310203        工学院   \n",
       "50                                               许仕凡  20231310202        工学院   \n",
       "51                                               傅景华  20231310201        工学院   \n",
       "52                                               高存平  20221310228        工学院   \n",
       "\n",
       "   Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8  \\\n",
       "0         NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "1          专业         班级        提交数        被批阅        最高分        最低分   \n",
       "2       大数据技术     数据2312       0/14        0/0          0          0   \n",
       "3       大数据技术     数据2312       0/14        0/0          0          0   \n",
       "4       大数据技术     数据2312      10/14       0/10          0          0   \n",
       "5       大数据技术     数据2312      13/14       0/13          0          0   \n",
       "6       大数据技术     数据2312      10/14       0/10          0          0   \n",
       "7       大数据技术     数据2312       9/14        0/9          0          0   \n",
       "8       大数据技术     数据2312       8/14        0/8          0          0   \n",
       "9       大数据技术     数据2312      11/14       0/11          0          0   \n",
       "10      大数据技术     数据2312      14/14       0/14          0          0   \n",
       "11      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "12      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "13      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "14      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "15      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "16      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "17      大数据技术     数据2312       0/14        0/0          0          0   \n",
       "18      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "19      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "20      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "21      大数据技术     数据2312      12/14       0/12          0          0   \n",
       "22      大数据技术     数据2312       0/14        0/0          0          0   \n",
       "23      大数据技术     数据2312       4/14        0/4          0          0   \n",
       "24      大数据技术     数据2312       4/14        0/4          0          0   \n",
       "25      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "26      大数据技术     数据2312       8/14        0/8          0          0   \n",
       "27      大数据技术     数据2312      11/14       0/11          0          0   \n",
       "28      大数据技术     数据2312       8/14        0/8          0          0   \n",
       "29      大数据技术     数据2312       4/14        0/4          0          0   \n",
       "30      大数据技术     数据2312       2/14        0/2          0          0   \n",
       "31      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "32      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "33      大数据技术     数据2312       9/14        0/9          0          0   \n",
       "34      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "35      大数据技术     数据2312       0/14        0/0          0          0   \n",
       "36      大数据技术     数据2312      12/14       0/12          0          0   \n",
       "37      大数据技术     数据2312      12/14       0/12          0          0   \n",
       "38      大数据技术     数据2312       9/14        0/9          0          0   \n",
       "39      大数据技术     数据2312       8/14        0/8          0          0   \n",
       "40      大数据技术     数据2312      10/14       0/10          0          0   \n",
       "41      大数据技术     数据2312       5/14        0/5          0          0   \n",
       "42      大数据技术     数据2312      12/14       0/12          0          0   \n",
       "43      大数据技术     数据2312       9/14        0/9          0          0   \n",
       "44      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "45      大数据技术     数据2312       8/14        0/8          0          0   \n",
       "46      大数据技术     数据2312       9/14        0/9          0          0   \n",
       "47      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "48      大数据技术     数据2312      13/14       0/13          0          0   \n",
       "49      大数据技术     数据2312       5/14        0/5          0          0   \n",
       "50      大数据技术     数据2312       1/14        0/1          0          0   \n",
       "51      大数据技术     数据2312       9/14        0/9          0          0   \n",
       "52      大数据技术     数据2312      12/14       0/12          0          0   \n",
       "\n",
       "    Unnamed: 9  \n",
       "0          NaN  \n",
       "1   平均分(计算已批阅)  \n",
       "2            0  \n",
       "3            0  \n",
       "4            0  \n",
       "5            0  \n",
       "6            0  \n",
       "7            0  \n",
       "8            0  \n",
       "9            0  \n",
       "10           0  \n",
       "11           0  \n",
       "12           0  \n",
       "13           0  \n",
       "14           0  \n",
       "15           0  \n",
       "16           0  \n",
       "17           0  \n",
       "18           0  \n",
       "19           0  \n",
       "20           0  \n",
       "21           0  \n",
       "22           0  \n",
       "23           0  \n",
       "24           0  \n",
       "25           0  \n",
       "26           0  \n",
       "27           0  \n",
       "28           0  \n",
       "29           0  \n",
       "30           0  \n",
       "31           0  \n",
       "32           0  \n",
       "33           0  \n",
       "34           0  \n",
       "35           0  \n",
       "36           0  \n",
       "37           0  \n",
       "38           0  \n",
       "39           0  \n",
       "40           0  \n",
       "41           0  \n",
       "42           0  \n",
       "43           0  \n",
       "44           0  \n",
       "45           0  \n",
       "46           0  \n",
       "47           0  \n",
       "48           0  \n",
       "49           0  \n",
       "50           0  \n",
       "51           0  \n",
       "52           0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy2312 = pd.read_excel('数据2312学生完成统计.xlsx' )\n",
    "zy2312"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: '数据2311学生签到统计详请.xlsx'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-11-55fd99d4ccb2>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mqd2312\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_excel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'数据2311学生签到统计详请.xlsx'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36mread_excel\u001b[1;34m(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols, **kwds)\u001b[0m\n\u001b[0;32m    302\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    303\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mExcelFile\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 304\u001b[1;33m         \u001b[0mio\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mExcelFile\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    305\u001b[0m     \u001b[1;32melif\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;33m!=\u001b[0m \u001b[0mio\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    306\u001b[0m         raise ValueError(\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, io, engine)\u001b[0m\n\u001b[0;32m    819\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_io\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mstringify_path\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    820\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 821\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engines\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_io\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    822\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    823\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m__fspath__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_xlrd.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m     19\u001b[0m         \u001b[0merr_msg\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m\"Install xlrd >= 1.0.0 for Excel support\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     20\u001b[0m         \u001b[0mimport_optional_dependency\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"xlrd\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mextra\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0merr_msg\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 21\u001b[1;33m         \u001b[0msuper\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__init__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     22\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     23\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m    351\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    352\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstr\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 353\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    354\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mbytes\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    355\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBytesIO\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_xlrd.py\u001b[0m in \u001b[0;36mload_workbook\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m     34\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mopen_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfile_contents\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     35\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 36\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mopen_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     37\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     38\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\xlrd\\__init__.py\u001b[0m in \u001b[0;36mopen_workbook\u001b[1;34m(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)\u001b[0m\n\u001b[0;32m    109\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    110\u001b[0m         \u001b[0mfilename\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mos\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexpanduser\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilename\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 111\u001b[1;33m         \u001b[1;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilename\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"rb\"\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    112\u001b[0m             \u001b[0mpeek\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpeeksz\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    113\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mpeek\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34mb\"PK\\x03\\x04\"\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;31m# a ZIP file\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: '数据2311学生签到统计详请.xlsx'"
     ]
    }
   ],
   "source": [
    "qd2311 = pd.read_excel('数据2311学生签到统计详请.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: '数据2312学生签到统计详请.xlsx'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-14-496dc803151e>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mqd2312\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_excel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'数据2312学生签到统计详请.xlsx'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mencoing\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'gbk'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36mread_excel\u001b[1;34m(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols, **kwds)\u001b[0m\n\u001b[0;32m    302\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    303\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mExcelFile\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 304\u001b[1;33m         \u001b[0mio\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mExcelFile\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    305\u001b[0m     \u001b[1;32melif\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;33m!=\u001b[0m \u001b[0mio\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    306\u001b[0m         raise ValueError(\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, io, engine)\u001b[0m\n\u001b[0;32m    819\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_io\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mstringify_path\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mio\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    820\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 821\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engines\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_io\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    822\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    823\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m__fspath__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_xlrd.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m     19\u001b[0m         \u001b[0merr_msg\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m\"Install xlrd >= 1.0.0 for Excel support\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     20\u001b[0m         \u001b[0mimport_optional_dependency\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"xlrd\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mextra\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0merr_msg\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 21\u001b[1;33m         \u001b[0msuper\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__init__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     22\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     23\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_base.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m    351\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    352\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mstr\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 353\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    354\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mbytes\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    355\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mload_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBytesIO\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel\\_xlrd.py\u001b[0m in \u001b[0;36mload_workbook\u001b[1;34m(self, filepath_or_buffer)\u001b[0m\n\u001b[0;32m     34\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mopen_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfile_contents\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     35\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 36\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mopen_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     37\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     38\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\xlrd\\__init__.py\u001b[0m in \u001b[0;36mopen_workbook\u001b[1;34m(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)\u001b[0m\n\u001b[0;32m    109\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    110\u001b[0m         \u001b[0mfilename\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mos\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexpanduser\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilename\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 111\u001b[1;33m         \u001b[1;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilename\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"rb\"\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    112\u001b[0m             \u001b[0mpeek\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpeeksz\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    113\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mpeek\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34mb\"PK\\x03\\x04\"\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;31m# a ZIP file\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: '数据2312学生签到统计详请.xlsx'"
     ]
    }
   ],
   "source": [
    "qd2312 = pd.read_excel('数据2312学生签到统计详请.xlsx',encoing='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生完成统计_x</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2_x</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4_x</th>\n",
       "      <th>Unnamed: 5_x</th>\n",
       "      <th>Unnamed: 6_x</th>\n",
       "      <th>Unnamed: 7_x</th>\n",
       "      <th>Unnamed: 8_x</th>\n",
       "      <th>Unnamed: 9_x</th>\n",
       "      <th>学生完成统计_y</th>\n",
       "      <th>Unnamed: 2_y</th>\n",
       "      <th>Unnamed: 4_y</th>\n",
       "      <th>Unnamed: 5_y</th>\n",
       "      <th>Unnamed: 6_y</th>\n",
       "      <th>Unnamed: 7_y</th>\n",
       "      <th>Unnamed: 8_y</th>\n",
       "      <th>Unnamed: 9_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生姓名</td>\n",
       "      <td>学号/工号</td>\n",
       "      <td>院系</td>\n",
       "      <td>专业</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "      <td>学生姓名</td>\n",
       "      <td>院系</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           学生完成统计_x Unnamed: 1 Unnamed: 2_x  \\\n",
       "0  课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31        NaN          NaN   \n",
       "1                                              学生姓名      学号/工号           院系   \n",
       "\n",
       "  Unnamed: 3 Unnamed: 4_x Unnamed: 5_x Unnamed: 6_x Unnamed: 7_x Unnamed: 8_x  \\\n",
       "0        NaN          NaN          NaN          NaN          NaN          NaN   \n",
       "1         专业           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_x                                          学生完成统计_y Unnamed: 2_y  \\\n",
       "0          NaN  课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31          NaN   \n",
       "1   平均分(计算已批阅)                                              学生姓名           院系   \n",
       "\n",
       "  Unnamed: 4_y Unnamed: 5_y Unnamed: 6_y Unnamed: 7_y Unnamed: 8_y  \\\n",
       "0          NaN          NaN          NaN          NaN          NaN   \n",
       "1           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_y  \n",
       "0          NaN  \n",
       "1   平均分(计算已批阅)  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy = pd.merge(zy2311,zy2312, on=['Unnamed: 1', 'Unnamed: 3'])\n",
    "zy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "qd = pd.merge(qd2311,qd2312)\n",
    "qd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生完成统计_x</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2_x</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4_x</th>\n",
       "      <th>Unnamed: 5_x</th>\n",
       "      <th>Unnamed: 6_x</th>\n",
       "      <th>Unnamed: 7_x</th>\n",
       "      <th>Unnamed: 8_x</th>\n",
       "      <th>Unnamed: 9_x</th>\n",
       "      <th>学生完成统计_y</th>\n",
       "      <th>Unnamed: 2_y</th>\n",
       "      <th>Unnamed: 4_y</th>\n",
       "      <th>Unnamed: 5_y</th>\n",
       "      <th>Unnamed: 6_y</th>\n",
       "      <th>Unnamed: 7_y</th>\n",
       "      <th>Unnamed: 8_y</th>\n",
       "      <th>Unnamed: 9_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生姓名</td>\n",
       "      <td>学号/工号</td>\n",
       "      <td>院系</td>\n",
       "      <td>专业</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "      <td>学生姓名</td>\n",
       "      <td>院系</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           学生完成统计_x Unnamed: 1 Unnamed: 2_x  \\\n",
       "0  课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31        NaN          NaN   \n",
       "1                                              学生姓名      学号/工号           院系   \n",
       "\n",
       "  Unnamed: 3 Unnamed: 4_x Unnamed: 5_x Unnamed: 6_x Unnamed: 7_x Unnamed: 8_x  \\\n",
       "0        NaN          NaN          NaN          NaN          NaN          NaN   \n",
       "1         专业           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_x                                          学生完成统计_y Unnamed: 2_y  \\\n",
       "0          NaN  课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31          NaN   \n",
       "1   平均分(计算已批阅)                                              学生姓名           院系   \n",
       "\n",
       "  Unnamed: 4_y Unnamed: 5_y Unnamed: 6_y Unnamed: 7_y Unnamed: 8_y  \\\n",
       "0          NaN          NaN          NaN          NaN          NaN   \n",
       "1           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_y  \n",
       "0          NaN  \n",
       "1   平均分(计算已批阅)  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    NaN\n",
       "1    被批阅\n",
       "Name: Unnamed: 6_x, dtype: object"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy['Unnamed: 6_x']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生完成统计_x</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2_x</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4_x</th>\n",
       "      <th>Unnamed: 5_x</th>\n",
       "      <th>Unnamed: 6_x</th>\n",
       "      <th>Unnamed: 7_x</th>\n",
       "      <th>Unnamed: 8_x</th>\n",
       "      <th>Unnamed: 9_x</th>\n",
       "      <th>学生完成统计_y</th>\n",
       "      <th>Unnamed: 2_y</th>\n",
       "      <th>Unnamed: 4_y</th>\n",
       "      <th>Unnamed: 5_y</th>\n",
       "      <th>Unnamed: 6_y</th>\n",
       "      <th>Unnamed: 7_y</th>\n",
       "      <th>Unnamed: 8_y</th>\n",
       "      <th>Unnamed: 9_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>学生姓名</td>\n",
       "      <td>学号/工号</td>\n",
       "      <td>院系</td>\n",
       "      <td>专业</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "      <td>学生姓名</td>\n",
       "      <td>院系</td>\n",
       "      <td>班级</td>\n",
       "      <td>提交数</td>\n",
       "      <td>被批阅</td>\n",
       "      <td>最高分</td>\n",
       "      <td>最低分</td>\n",
       "      <td>平均分(计算已批阅)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           学生完成统计_x Unnamed: 1 Unnamed: 2_x  \\\n",
       "0  课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31        NaN          NaN   \n",
       "1                                              学生姓名      学号/工号           院系   \n",
       "\n",
       "  Unnamed: 3 Unnamed: 4_x Unnamed: 5_x Unnamed: 6_x Unnamed: 7_x Unnamed: 8_x  \\\n",
       "0        NaN          NaN          NaN          NaN          NaN          NaN   \n",
       "1         专业           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_x                                          学生完成统计_y Unnamed: 2_y  \\\n",
       "0          NaN  课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31          NaN   \n",
       "1   平均分(计算已批阅)                                              学生姓名           院系   \n",
       "\n",
       "  Unnamed: 4_y Unnamed: 5_y Unnamed: 6_y Unnamed: 7_y Unnamed: 8_y  \\\n",
       "0          NaN          NaN          NaN          NaN          NaN   \n",
       "1           班级          提交数          被批阅          最高分          最低分   \n",
       "\n",
       "  Unnamed: 9_y  \n",
       "0          NaN  \n",
       "1   平均分(计算已批阅)  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                           学生完成统计_x Unnamed: 1 Unnamed: 2_x  \\\n",
      "0  课程：数据预处理技术    班级：数据2311#数据预处理技术  导出时间：2024-12-31        NaN          NaN   \n",
      "1                                              学生姓名      学号/工号           院系   \n",
      "\n",
      "  Unnamed: 3 Unnamed: 4_x Unnamed: 5_x Unnamed: 6_x Unnamed: 7_x Unnamed: 8_x  \\\n",
      "0        NaN          NaN          NaN          NaN          NaN          NaN   \n",
      "1         专业           班级          提交数          被批阅          最高分          最低分   \n",
      "\n",
      "  Unnamed: 9_x                                          学生完成统计_y Unnamed: 2_y  \\\n",
      "0          NaN  课程：数据预处理技术    班级：数据2312#数据预处理技术  导出时间：2024-12-31          NaN   \n",
      "1   平均分(计算已批阅)                                              学生姓名           院系   \n",
      "\n",
      "  Unnamed: 4_y Unnamed: 5_y Unnamed: 6_y Unnamed: 7_y Unnamed: 8_y  \\\n",
      "0          NaN          NaN          NaN          NaN          NaN   \n",
      "1           班级          提交数          被批阅          最高分          最低分   \n",
      "\n",
      "  Unnamed: 9_y  \n",
      "0          NaN  \n",
      "1   平均分(计算已批阅)  \n"
     ]
    }
   ],
   "source": [
    "print(zy)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "qd_sorted = sorted()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
